package cn.gson.fengboot.model.mapper;

import cn.gson.fengboot.model.pojos.*;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface DbusinessMapper {
    /*查询所有商机*/
    List<Dbusiness> selectbusiness(@Param("busName") String busName,
                                   @Param("busPeople") String busPeople, @Param("phaseName") String phaseName
    );

    /*根据客户ID查询商机*/
    List<Dbusiness> kehushangji(@Param("search") String search, @Param("search2") String search2);


    /*根据客户查询联系人*/
    List<TfylinkmanForm> selectmainlinkman(@Param("search") String search, @Param("linkmanName") String linkmanName);

    /*根据产品ID查询产品信息*/
    List<Qproductdetail> allpro(@Param("proName") String proName);

    /*根据Id查询商机对象*/
    Dbusiness selectBybusId(@Param("busId") Integer busId);

    /*查询商机是否有合同*/
    Zcontract selectConById(@Param("busId") Integer busId);


    List<TfyclientForm> allclientbyemp(@Param("search") String search, @Param("busPeople") Integer busPeople);

}
